An Online Analytical Processing (OLAP) Database for Agricultural Policy Data: a Greek Case Study
نویسندگان
چکیده
Statistical data for agricultural policy analysis has certain unique features: a multitude of sources of very different nature; a variety of dimensional granularity; different end user requirements. The utilization of Data Warehouse technology would be valuable for overcoming the above data issues. Ιn this paper, we describe the technologies involved and the data modeling requirements, making an exemplar implementation for few tables of the Greek agricultural census.
منابع مشابه
Design and Implementation of On-line Analytical Processing (olap) of Spatial Data Design and Implementation of On-line Analytical Pro- Cessing (olap) of Spatial Data
On-line analytical processing (OLAP) has gained its popularity in database industry. With a huge amount of data stored in spatial databases and the introduction of spatial components to many relational or object-relational databases, it is important to study the methods for spatial data warehousing and on-line analytical processing of spatial data. This thesis investigates methods for spatial O...
متن کاملInteractive ROLAP on Large Datasets: A Case Study with UB-Trees
Online Analytical Processing (OLAP) requires query response times within the range of a few seconds in order to allow for interactive drilling, slicing, or dicing through an OLAP cube. While small OLAP applications use multidimensional database systems, large OLAP applications like the SAP BW rely on relational (ROLAP) databases for efficient data storage and retrieval. ROLAP databases use spec...
متن کاملSelective Materialization: an Eecient Method for Spatial Data Cube Construction
On-line analytical processing (OLAP) has gained its popularity in database industry. With a huge amount of data stored in spatial databases and the introduction of spatial components to many relational or object-relational databases, it is important to study the methods for spatial data warehousing and on-line analytical processing of spatial data. In this paper, we study methods for spatial OL...
متن کاملData Warehousing, Data Mining, OLAP and OLTP Technologies Are Indispensable Elements to Support Decision-Making Process in Industrial World
This paper provides an overview of Data warehousing, Data Mining, OLAP, OLTP technologies, exploring the features, new applications and the architecture of Data Warehousing and data mining. The data warehouse supports on-line analytical processing (OLAP), the functional and performance requirements of which are quite different from those of the online transaction processing (OLTP) applications ...
متن کاملNormalization in a Mixed OLTP and OLAP Workload Scenario
The historically introduced separation of online analytical processing (OLAP) from online transaction processing (OLTP) is in question considering the current developments of databases. Columnoriented databases mainly used in the OLAP environment so far, with the addition of in-memory data storage are adapted to accommodate OLTP as well, thus paving the way for mixed OLTP and OLAP processing. T...
متن کامل